SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create Procedure [dbo].[spThemNhanVien]
	@tenNV nvarchar(50),
	@cMND char(9),
	@diaChi nvarchar(100),
	@sDT varchar(15),
	@ngaySinh datetime ,
	@maLoaiNV int,
	@maNH int,
	@ngayLam datetime,
	@usename nvarchar(50),
	@password nvarchar(50),
	@login int
As
Begin
	Insert Into NhanVien
	(
		TenNV,
		CMND,
		DianChi,
		SDT,
		NgaySinh,
		MaLoaiNV,
		MaNH,
		NgayLam,
		Username,
		Password,
		Login
		
	)
	Values
	(
		@tenNV,
		@cMND,
		@diaChi,
		@sDT,
		@ngaySinh,
		@maLoaiNV,
		@maNH,
		@ngayLam,
		@usename,
		@password,
		@login
	)
End